<%@ page language="java" contentType="text/html; charset=UTF-8"
    pageEncoding="UTF-8"%>
<%@ page import="java.sql.*"%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=ISO-8859-1">
<link rel="stylesheet" type="text/css" href="../css/public.css">
<title>审核学生信息</title>
</head>
<body>
<% 
	String managerName = (String) session.getAttribute("managerName");
	String classId = (String) session.getAttribute("classId");
	if(managerName == null)
    	out.println("<script>alert('没有登录,请返回登录界面进行登录！');window.location='../managerLogin.html';</script>");
	String stuId="";
	String stuName="";
	String stuSex="";
	String stuPwd="";
	Class.forName("com.mysql.jdbc.Driver").newInstance();
	Connection con = java.sql.DriverManager.getConnection("jdbc:mysql://localhost:3306/classfee", "root", "1234");
	Statement stmt = con.createStatement();
	ResultSet rst = stmt.executeQuery("SELECT * FROM  tb_check where classId='"+classId+"' and checkSet=0");
%>
<div id="maincontent">
<div id="headGray">
<ul class="nopoint"><li><img src="../image/head.png" style="width:30px;height:30px"/><a id="maname" href="managerupdate1.jsp" style="color:white;text-decoration: none;"><% out.println(managerName);%></a><a href="../managerlogout.jsp" style="margin-left:89%;color:white">退出登录</a></li></ul>
</div>
<div id="infotable">
   	<table  border="1" rules=rows  style="margin-left:37%;margin-top:50px">
		<tr align="center">
			<td>学号</td>
	        <td>姓名</td>
		    <td>性别</td>
		    <td colspan="2">操  作</td>
		</tr>
		<%while(rst.next()){
			stuId=rst.getString("stuId");
			session.setAttribute("stuId",stuId);
			stuName=rst.getString("stuName");
			session.setAttribute("stuName",stuName);
			stuSex=rst.getString("stuSex");
			session.setAttribute("stuSex",stuSex);
			stuPwd=rst.getString("stuPwd");
			session.setAttribute("stuPwd",stuPwd);
		%>
		<tr align="center">
		<td><%out.println(stuId);%></td>
		<td><%out.println(stuName);%></td>
		<td><%out.println(stuSex);%></td>
		<td><input type="button" value="通 过" id="pass" onclick="window.location='checkStuInfo.jsp'"></td>
		<td><input type="button" value="拒 绝" id="refuse" onclick="window.location='checkStuInfo2.jsp'"></td>
		</tr>
		<%}%>
		<%
			rst.close(); 
			stmt.close();
			con.close();
		%>
	</table>
</div>
</div>
</body>
</html>